package com.sea.finance.mapper;


import com.sea.finance.entity.Vt;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 *  汇率表接口
 * @author 陈鸿飞
 * <br/>
 */
public interface VtMapper {

    Integer insert(Vt vt);

    Integer reload();

    Integer updateFeeName();

    Integer updateFnSku();

    Integer updateListingName();

    List<Vt> findByDealSku(Vt vt);

    Integer update(Vt vt);

    List<Map<String,Object>> findByReport(Vt vt);

    List<Map<String,Object>> findNullByReport(Vt vt);

    List<Map<String,Object>> findListingByReport(Vt vt);


    List<Vt> findByNonAmazon(Vt vt);




    Integer delete(@Param("period")String period,
                   @Param("shopName")String shopName,
                   @Param("brandName")String brandName,
                   @Param("countryName")String countryName);

    Integer deleteTitle();

    Integer deleteUSPeriod(@Param("countryName") String countryName);

    Integer deletEUPeriod(@Param("countryName") String countryName);

    void deleteByNonAmazonOrder(String orderId);

    void updateAmazonByOrderId(String orderId);

    List<Vt> findByFeeName(@Param("feeName")String feeName);

}